/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package br.com.sysdrive.controller.Relatorio;

import br.com.sysdrive.util.ConnectionFactory;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperRunManager;

/**
 *
 * @author Willian Frias
 */
public class ChamarRelatorio extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        System.out.println("Passo no servelt");
        
        ServletOutputStream servletOutputStream = response.getOutputStream();
        HttpSession sessao = request.getSession();
        

        // pega o caminho onde estao os relatorios
        String caminho = getServletContext().getRealPath("")+"/Relatorios/";
        String relatorio = caminho + request.getParameter("nome") +".jasper";
        String parametro_where = request.getParameter("parametro");
        Map parametros = new HashMap( );
        parametros.put("PARAMETRO_WHERE", parametro_where);
        
        System.out.println(parametro_where);

        Connection conn = null;

        try {
            conn = ConnectionFactory.getConnection();
            System.out.println("Conexao do relatorio com o banco de dados realizada com sucesso!");

            byte[] bytes = null;
            //envia o relatoio em formato PDF para o browser
            bytes = JasperRunManager.runReportToPdf(relatorio, parametros, conn);

            if (bytes != null && bytes.length > 0) {
                response.setContentType("application/pdf");
                response.setContentLength(bytes.length);
                ServletOutputStream ouputStream = response.getOutputStream();
                ouputStream.write(bytes, 0, bytes.length);
                ouputStream.flush();
                ouputStream.close();
            }
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(ChamarRelatorio.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(ChamarRelatorio.class.getName()).log(Level.SEVERE, null, ex);
        } catch (JRException e) {
            Logger.getLogger(ChamarRelatorio.class.getName()).log(Level.SEVERE, null, e);
        } catch (Exception ex) {
            System.out.println("Problemas ao gerar relatorio! Erro: " + ex.getMessage());
        } finally {
            servletOutputStream.flush();
            servletOutputStream.close();

            try {
                ConnectionFactory.closeConnection(conn);
            } catch (SQLException ex) {
                Logger.getLogger(ChamarRelatorio.class.getName()).log(Level.SEVERE, null, ex);
            } catch (Exception ex) {
                System.out.println("Problemas ao fechar parametros de conexao do relatorio! Erro: " + ex.getMessage());

            }
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}





    